Tabela CO_L_PRODUCTIONORDER

Definicja tabeli CO_L_PRODUCTIONORDER

Name

CO_L_PRODUCTIONORDER

Code

CO_L_PRODUCTIONORDER

Comment

tabela linkujaca produkcje z zamowieniem na posilki


Lista kolumn tabeli CO_L_PRODUCTIONORDER

Name

Code

LPRODUCTIONORDERID

LPRODUCTIONORDERID

PRODUCTIONID

PRODUCTIONID

ORDERID

ORDERID

INSERTDATE

INSERTDATE

INSERTINGPERSON

INSERTINGPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDPERSON

LASTMODIFIEDDT

LASTMODIFIEDDT


Kolumna LPRODUCTIONORDERID tabeli CO_L_PRODUCTIONORDER

Definicja kolumny LPRODUCTIONORDERID tabeli CO_L_PRODUCTIONORDER

Name

LPRODUCTIONORDERID

Code

LPRODUCTIONORDERID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glowny


Kolumna PRODUCTIONID tabeli CO_L_PRODUCTIONORDER

Definicja kolumny PRODUCTIONID tabeli CO_L_PRODUCTIONORDER

Name

PRODUCTIONID

Code

PRODUCTIONID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

produkcja posilku


Kolumna ORDERID tabeli CO_L_PRODUCTIONORDER

Definicja kolumny ORDERID tabeli CO_L_PRODUCTIONORDER

Name

ORDERID

Code

ORDERID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

zamowienie


Kolumna INSERTDATE tabeli CO_L_PRODUCTIONORDER

Definicja kolumny INSERTDATE tabeli CO_L_PRODUCTIONORDER

Name

INSERTDATE

Code

INSERTDATE

Data Type

DATE

Mandatory

No

Comment

 


Kolumna INSERTINGPERSON tabeli CO_L_PRODUCTIONORDER

Definicja kolumny INSERTINGPERSON tabeli CO_L_PRODUCTIONORDER

Name

INSERTINGPERSON

Code

INSERTINGPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDPERSON tabeli CO_L_PRODUCTIONORDER

Definicja kolumny LASTMODIFIEDPERSON tabeli CO_L_PRODUCTIONORDER

Name

LASTMODIFIEDPERSON

Code

LASTMODIFIEDPERSON

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LASTMODIFIEDDT tabeli CO_L_PRODUCTIONORDER

Definicja kolumny LASTMODIFIEDDT tabeli CO_L_PRODUCTIONORDER

Name

LASTMODIFIEDDT

Code

LASTMODIFIEDDT

Data Type

DATE

Mandatory

No

Comment

 


Lista kluczy tabeli CO_L_PRODUCTIONORDER

Name

Code

Primary

PK_CO_L_PRODUCTIONORDER

PK_CO_L_PRODUCTIONORDER

X


Klucz PK_CO_L_PRODUCTIONORDER tabeli CO_L_PRODUCTIONORDER

Definicja klucza PK_CO_L_PRODUCTIONORDER tabeli CO_L_PRODUCTIONORDER

Name

PK_CO_L_PRODUCTIONORDER

Code

PK_CO_L_PRODUCTIONORDER

Primary

Yes

Comment